MySQL Vs SQL
MySQL and SQL are the top leading databases that supports the front end applications that relates various domains.Lets check out the distinct features between the MySQL and SQL Server.
MySQL | SQL Server |
---|---|
MySQL is available for free since it is an open source. | SQL Server is not an open source and have to make a payment to use it. |
MySQL offers only updateable views. | SQL Server offers indexed views which are much more powerful,performance wise. |
MySQL does not support XML. | SQL Server supports XML. |
MySQL provides only table level security. | SQL Server provides column level security. |
MySQL does not offer any certification for security. | SQL Server has C2 complaint certification.Database security is verified by third party. |
Earlier versions of MySQL does not supports triggers.Only MySQL version 5.0 supports trigggers. | SQL Server provides triggers. |
User Defined Functions are not supported in MySQL. | User Defined Functions are supported in SQL. |
Cursor feature is not available in MySQL. | Cursor feature is available in SQL Server. |
MySQL was developed by Oracle. | SQL Server was developed by Microsoft. |
MySQL supports many platforms as compared to SQL Server. | SQL Server supports only Linux and Windows platforms. |
It is found that MySQL Syntax is little bit complex. | SQL Server syntax is simpler and easy to use. |
MySQL was mainly in programmed in C and C++ programming language. | SQL Server was mainly programmed in C++ but some parts in C as well. |
MySQL - Grant_ Revoke Privilege
posted on 2019-11-26 23:15:04 - mysql Tutorials